<?php
    @session_start();
    
	// Includes obligatorios
	include ('./dbconfig.php');
	include ('./administration/Libraries/Tools/JLTools.class.php');
	$jl = new JLTools();
	
	$SQL = "SELECT 
	  tbl_actualites.int_actualite,
	  tbl_actualites.txt_content_actualite,
	  tbl_actualites.var_monthyear,
	  tbl_actualites.dat_creation_act,
	  tbl_sections.var_desc_section,
	  tbl_sections.int_id_section,
	  tbl_states.var_htmldesc
	FROM
	  tbl_sections
	  INNER JOIN tbl_actualites ON (tbl_sections.int_id_section = tbl_actualites.int_id_section)
	  INNER JOIN tbl_states ON (tbl_actualites.int_id_state = tbl_states.int_id_state)
	WHERE tbl_actualites.int_id_state <> 3
	ORDER BY tbl_actualites.int_actualite DESC";
	
	$res = mysql_query($SQL,$cnn);

?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="fr-fr" lang="fr-fr" >
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<meta name="robots" content="index, follow" />
<meta http-equiv="pragma" content="no-cache" />
<meta name="language" content="fr-fr" />
<meta name="keywords" content="site web csme.fr csme CSME, club sportif multisections d'épinay-sur-seine, épinay-sur-seine, 93800, club sportif, arts martiaux, athlétisme, basket ball, boule spinassienne, boxe française, colombophilie, culturisme, cyclisme, cyclotourisme, échecs, escalade, escrime, gym entretien, gym tonic, gym artistique, marche randonnée, muay thaï, natation, pétanque, plongée sous marine, tennis, tir a l'arc, volley ball, yoga, sports, épinay, adhésion, compétitions, résultats, actualités épinay, informations sportives" />
<meta name="description" content="CSME Club Sportif Multisections d'épinay-sur-seine. épinay-sur-seine 6, avenue de Lattre de Tassigny 93800 Epinay-sur-Seine, Tel. 01.48.29.75.63 info@csme.fr - Gérard BRAGLIA, Dir. Administratif et Financier, Tel. 01.49.71.32.85, directeur@csme.fr" />
<meta name="generator" content="LBN | Design & Development Studio" />
<title>Club Sportif Multisections d’Epinay-sur-Seine</title>
<link href="base.css" rel="stylesheet" type="text/css" media="screen, projection" charset="utf-8" />
<!--[if IE 7]>
<link href="base-ie7.css" rel="stylesheet" type="text/css" media="screen, projection" charset="utf-8" />
<![endif]-->
<link href="./slider/stylesheets/slider-footer.css" rel="stylesheet" type="text/css" media="screen, projection" charset="utf-8" />
<link href="./slider/stylesheets/slider-popup.css" rel="stylesheet" type="text/css" media="screen, projection" charset="utf-8" />
<script type="text/javascript" src="./slider/javascripts/jquery-1.3.2.min.js"></script>
<script type="text/javascript" src="./administration/Resouces/js/jquery.simplemodal-1.3.3.js"></script>
<script type="text/javascript" src="./slider/javascripts/jquery.coda-slider-2.0.js"></script>
<script type="text/javascript" src="./slider/javascripts/jquery.easing.1.3.js"></script>
<script type="text/javascript" src="./js/jquery.tooltip.min.js"></script>
<script type="text/javascript" src="./js/js-submenu-lessections.js"></script>
<script type="text/javascript" src="./js/js-newsletter.js"></script>
<script type="text/javascript" src="./js/js-formlogin.js"></script>
<link rel="shortcut icon" href="images/favicon.ico" type="image/x-icon" />

</head>
<body>

<!-- BN-TOP -->
<div id="bn-top">    



    <!-- MENU-TOP -->
	<div class="menu-top">


		<!-- ACTUALITES -->
        <div id="actualites">

        	<div class="act-top"></div>
        	<div class="act-content">
            	<div class="act-icon"></div>
                <div class="act-bienvenue">
                  <h2>Bienvenue</h2>
                  <span>sur le site du CSME</span>
                </div>
                <span class="act-title">Actualités</span>
                <div class="act-panel">
                <?php    
                 
				 $sql = "SELECT 
					  var_monthyear
					FROM 
					  tbl_actualites
					WHERE int_id_section < 3 && int_id_section !=0 && int_id_state != 3
					GROUP BY var_monthyear
					ORDER BY int_actualite DESC";
				
				$resr = mysql_query($sql, $cnn);
				$ord = 1;
				while ($fila = mysql_fetch_assoc($resr)){
					$groupmonth[ $fila['var_monthyear'] ] = $ord;
					$ord++;
				}

                $t = mysql_num_rows($res);
				$i = 1;
				while ($row = mysql_fetch_assoc($res)){
				?>
					<div>
	                    <dt class="act-date"><?php echo $row['dat_creation_act']; ?></dt>
                        <span class="sub-title2" style="font-size:10px; color:#666">Section: <strong style="font-weight:bold;"><?php echo $row['var_desc_section']; ?></strong></span> 
						<p><?php echo $jl->short_string( strip_tags($row['txt_content_actualite']), 100 ); ?></p>
                        
                        <?php 
							$ide 	= intval(trim($row['int_id_section']))-2;
							$idact 	= $row['int_actualite'];
							
							$SQL = "SELECT COUNT(`int_id_gallery`) AS 'num_gall' FROM `tbl_gallery` WHERE int_id_state != 3 AND  int_num_photos != 0  AND int_id_sections_view = ".$ide;
							$resk = mysql_query($SQL,$cnn);
							$rowk = mysql_fetch_assoc($resk);
							if(intval($rowk['num_gall'])>0) $_t = intval( $rowk['num_gall'] )+5;
							else $_t = 5;
							
							if($ide<=0){
                                $_url = 'actualites.html?act='.$idact.'#'.$groupmonth[$row['var_monthyear']];
							}else{
                                $_url = 'section.html?id='.$ide."&act=".$idact."#".$_t;
                            }
						?>
                        
						<dt class="act-more"><a href="<?php echo $_url; ?>" class="act-more">[lire plus]</a></dt>     
	                </div>
	        	<?php
	        		if($t != $i){
				?>	
						<!-- LINE -->
                    	<dl class="act-line"></dl>
                    	<!-- END LINE -->
				<?php
						$i++;
					}
				}
				
				?> 
              </div>
                <dt class="act-title-bottom">
                <a href="actualites.html" title="Actualités" target="_parent">VOIR TOUTES L’ACTUALITÉS</a></dt>                
            </div>
   
            <div style="background:url(images/btn_actualites-08.png) no-repeat; height:17px;"></div>

		</div>
        <!-- END ACTUALITES -->
        
        

         <!-- NEWSLETTER -->
        <div id="newsletter">
            <div class="newscenter">
                <div class="newscontent">
                  <h3><img src="images/sobre.png" width="16" height="12" /> Newsletter</h3>
                  <div class="subtitle">Recevez notre newsletter.</div>
                  <div><form action="?" method="post" enctype="application/x-www-form-urlencoded" name="frmnewsletter" id="frmnewsletter">
                   	<table border="0" cellpadding="0" cellspacing="0">
                    <tr>
                      <td><input name="txtnom" type="text" class="txtnewsletter" value="Nom &amp; Prénom" id="txtnom" /></td>
                      <td></td>
                    </tr>
                    <tr>
                    <td><input name="txtemail" type="text" class="txtnewsletter" value="Votre e-mail" id="txtemail"/></td>
                    <td><img title="Registraire" class="submitimagehidden2" style="position:absolute; margin-left:2px; margin-top:-3px;" src="images/btn-sub.png" /></td>
                    </tr>
                    </table> <input class="submithidden" type="submit" value="&nbsp;" />
                    <div style="padding:2px;"></div>
                  </form>
                  </div>
                  
                  
                  <div id="partenaires">
                  <div class="linepart"><img src="images/barra_gris.png" width="172" height="2" /></div>
                  <div id="titlepart"><img class="imgescudo" src="images/escudo.png" width="14" height="16" align="absmiddle" />Partenaires<img class="imgflecha" src="images/flecha.png" width="13" height="7" align="top" /></div>
                    
                  <div id="linkpart"><a href="javascript:;" target="_parent">Voir la liste de nos partenaires</a></div>
                  
                  </div>
                  
              </div> 
                <div class="newsbottom"></div>
            </div>
            <div class="newsright"></div>
            <div style="background:url(images/btn_newsletter-04.png) no-repeat; height:17px;"></div>
		</div>
        <!-- END NEWSLETTER -->

        <!-- MENU -->
    	<ul>
        	<li><a href="./" target="_parent"><dt class="accueil select"></dt></a></li>
            <li><a href="presentation.html" target="_parent"><dt class="presentation"></dt></a></li>
            <li><a href="javascript:void(0)" id="les_sections_id"><dt class="les_sections"></dt></a>
            
            <div id="ls-submenu">
                <div class="ls-top"></div>
                        <div class="ls-content">
                            <div class="ls-left">
                                <a class="btn_artsmartiaux" href="section.html?id=1"></a>
                                <a class="btn_athletisme" href="section.html?id=2"></a>
                                <a class="btn_basketball" href="section.html?id=3"></a>
                                <a class="btn_bouleespin" href="section.html?id=4"></a>
                                <a class="btn_boxefr a_bottom" href="section.html?id=5"></a>
                                <a class="btn_colombophilie" href="section.html?id=6"></a>
                                <a class="btn_culturisme" href="section.html?id=7"></a>
                                <a class="btn_cyclisme" href="section.html?id=8"></a>
                                <a class="btn_cyclotourisme" href="section.html?id=9"></a>
                                <a class="btn_echecs" href="section.html?id=10"></a>  
                                <a class="btn_escalade" href="section.html?id=11"></a>
                                <a class="btn_escrime" href="section.html?id=12"></a>  
                            </div>
                            <div class="ls-right">    
                                <a class="btn_gymentretien" href="section.html?id=13"></a>
                                <a class="btn_gymtonic" href="section.html?id=14"></a>
                                <a class="btn_gymartistique a_bottom" href="section.html?id=15"></a>
                                <a class="btn_marcherando a_bottom" href="section.html?id=16"></a>
                                <a class="btn_muaythai" href="section.html?id=17"></a>
                                <a class="btn_natation" href="section.html?id=18"></a>
                                <a class="btn_petanque a_bottom" href="section.html?id=19"></a>
                                <a class="btn_plongeesmarine" href="section.html?id=20"></a>
                                <a class="btn_tennis" href="section.html?id=21"></a>
                                <a class="btn_tirarc" href="section.html?id=22"></a>  
                                <a class="btn_volleyball" href="section.html?id=23"></a>  
                                <a class="btn_yoga" href="section.html?id=24"></a>   
                            </div>
                        </div>
                        <div class="ls-bottom"></div>
                </div>
            </li>
            <li><a href="actualites.html" target="_parent"><dt class="actualites"></dt></a></li>
            <li><a href="administration.html" target="_parent"><dt class="administration"></dt></a></li>
          	<li><a href="contacts.html" target="_parent"><dt class="contacts"></dt></a></li>
        </ul>
        <!-- END MENU-->

    </div>
    <!-- END MENU-TOP -->

</div>
<!-- END BN-TOP -->


<!-- BN-CONTENT-->

<div id="bn-content">

    

    <!-- BN-BGN-IMAGE-->
    <div><img id="bgn-image" src="images/index.jpg" width="1039" height="712" /></div>
    <!-- END BN-BGN-IMAGE-->

    <!-- SUB MENU FOOTER -->
    <div id="smmenulessections">
        <div class="sm-top"></div>
        <div class="sm-center">
            <div class="sm-center-content">
                <a href="section.html?id=1">Arts Martiaux</a>
                <a href="section.html?id=2">Athlétisme</a>
                <a href="section.html?id=3">Basketball</a>
                <a href="section.html?id=4">Boule Spinassienne</a>
                <a href="section.html?id=5">Boxe Française</a>
                <a href="section.html?id=6">Colombophilie</a>
                <a href="section.html?id=7">Culturisme</a>
                <a href="section.html?id=8">Cyclisme</a>
                <a href="section.html?id=9">Cyclotourisme</a>
                <a href="section.html?id=10">Echecs</a>  
                <a href="section.html?id=11">Escalade</a>
                <a href="section.html?id=12">Escrime</a>  
    
                <a href="section.html?id=13">Gym Entretien</a>
                <a href="section.html?id=14">Gym Tonic</a>
                <a href="section.html?id=15">Gym Artistique</a>
                <a href="section.html?id=16">Marche Randonnée</a>
                <a href="section.html?id=17">Muay Thaï</a>
                <a href="section.html?id=18">Natation</a>
                <a href="section.html?id=19">Pétanque</a>
                <a href="section.html?id=20">Plongée Sous Marine</a>
                <a href="section.html?id=21">Tennis / Badminton</a>
                <a href="section.html?id=22">Tir à l’arc</a>  
                <a href="section.html?id=23">Volley All</a>  
                <a href="section.html?id=24">Yoga</a>  
            </div>
        </div>
        <div class="sm-bottom"></div>
    </div>
    <!-- END SUB MENU FOOTER -->
    

    <!-- BN FOOTER -->
    <div class="bn-footer">
    <div style="position:absolute; background:url(images/index-12.png); width:10px; height:173px;"></div>
	<div class="f-connect">
    <div id="login-msg"></div>
    <div class="f-connect-left"></div> 

	<div class="f-connect-center"> Connection <span id="lbn-loading"></span></div>

            <div class="f-connect-right"></div>

            <div class="f-connect-login">

              <form id="formlogin" action="?" method="post" enctype="application/x-www-form-urlencoded" name="formlogin">
                <input name="txtlogin" type="text" class="txtlogin" value="Login" id="txtlogin" />
                <input name="txtpassword" type="password" class="txtlogin" value="Password" id="txtpassword" />
                <img title="Login" src="images/btn-sub.png" width="19" height="21" class="submitimagehidden" />  
                <input class="submithidden" type="submit" value="&nbsp;" />
           	  </form>

            </div>

        </div>

      	<div class="f-line"></div>
      	
       <div id="t-tooltip-footer-ess" class="tooltiplogo">
            <div class="t-top"></div>
            <div class="t-middle">
            	<img src="images/escudo.png" width="14" height="16"><span class="t-title">Info:</span><br />
                Ville d'Epinay sur Seine.<br />
				Partenaire officiel du CSME.<br />
                <span class="t-link">
                	--<br />
                	<a href="http://www.epinay-sur-seine.fr" target="_blank">Voir site web</a><br />
                    --                    
                </span>
         </div>
            <div class="t-bottom"></div>
      </div>
        
        <div id="t-tooltip-footer-ffco" class="tooltiplogo">
            <div class="t-top"></div>
            <div class="t-middle">
            	<img src="images/escudo.png" width="14" height="16"><span class="t-title">Info:</span><br />
               	la F.F.C.O./ Féderation Française des Clubs Omnisports.<br />
				Partenaire officiel du CSME.<br />
                <span class="t-link">
                	--<br />
                	<a href="http://www.ffco.org" target="_blank">Voir site web</a><br />
                    --                    
                </span>
          </div>
            <div class="t-bottom"></div>
        </div>
        
      <div id="t-tooltip-footer-idfrance" class="tooltiplogo">
        <div class="t-top"></div>
            <div class="t-middle">
            	<img src="images/escudo.png" width="14" height="16"><span class="t-title">Info:</span><br />
            	Région Île-de-France / conseil régional d'Île-de-France.<br />
				Partenaire officiel du CSME.<br />
                <span class="t-link">
                	--<br />
                	<a href="http://www.iledefrance.fr" target="_blank">Voir site web</a><br />
                    --
                </span>					
        </div>
            <div class="t-bottom"></div>
        </div>
    
    
    <div id="t-partenaires-footer">
        <div id="titleSlider"><img src="images/escudo.png" width="14" height="16" align="absmiddle" />Partenaires <img src="images/flecha.png" width="13" height="7" /></div>
        <div id="subtitleSlider"><a id="linkpartfooter" href="javascript:;">Voir la liste complète</a></div>
    </div>
    
<div class="f-ess"><a class="tooltip" href="http://www.epinay-sur-seine.fr" target="_blank"><img id="part-ess" src="images/logo_epinay.png" width="176" height="27" /></a></div>
 
<div class="f-ffco"><a class="tooltip" href="http://www.ffco.org/" target="_blank"><img id="part-ffco" src="images/ffco.png" width="75" height="68" /></a></div>

<div class="f-idfrance"><a class="tooltip" href="http://www.iledefrance.fr" target="_blank"><img id="part-idfrance" src="images/iledefrance.png" width="146" height="30" /></a></div>
   

  		<div class="f-line2"></div>
               
		<div class="f-bottom-menus">
                <a href="./" title="Accueil" target="_parent" class="select">Accueil</a> | 
                <a href="presentation.html" id="sm-presentation" title="Présentation" target="_parent">Présentation</a> | 
                <a href="javascript:void(0)" id="sm-lessections" title="Les sections">Les sections <img src="images/btn_sub_foot.png" width="11" height="10" /></a> | 
                <a href="actualites.html" id="sm-actualites" title="Actualités" target="_parent">Actualités</a> | 
                <a href="administration.html" id="sm-actualites" title="Administration" target="_parent">Administration</a> | 
                <a href="contacts.html" title="Contacts" target="_parent">Contacts</a>
</div>

  		<div class="f-right-note">
  			<div class="f-rn-img"><img src="images/48x48/pdf.png" width="48" height="48" /></div>
            <div class="f-rn-text">
           	<a href="pdf/reglement_financier_csme.pdf" target="_blank">Règlement Financier</a><br />
			<a href="pdf/reglement_interieur_csme.pdf" target="_blank">Règlement Interieur</a><br />
		   	<a href="pdf/statuts_csme.pdf" target="_blank">Statuts CSME</a></div>            
   	  	</div>

        <div class="f-lbn-logo">
    <a href="http://www.labolsanegra.org/" title="Powered by LBN | Design & Development Studio" target="_blank"><img src="images/logo-lbn.png" width="63" height="25" /></a></div>

	  	  <div class="f-copy">
            © Copyright 2009-2010. Club Sportif Multisections d’Epinay-sur-Seine. Tous droits réservés - <a href="mailto:info@csme.fr">info@csme.fr</a> - <em style="font-style:italic; font-weight:bold;"><?php include("./5G7KsI3Utn55YukQyNtAqU44/index.php"); ?></em>        
   	  </div>
      <div style="position:absolute; margin-left:1029px; background:url(images/index-13.png); width:10px; height:173px;"></div>
  </div>
    <!-- END BN FOOTER-->

    

</div>

<!-- BN-CONTENT-->

<div id="msg-newletter">
    <div>
        <strong>Merci.</strong> <br />
        <em>Nous vous adresserons par e-mail les prochaines nouvelles et informations exclusives sur le CSME.</em>
    </div>
</div>


<?php 
	$sql = "SELECT 
	  tbl_partenaires.id_int_partenaire,
	  tbl_partenaires.int_page,
	  tbl_logos.var_title,
	  tbl_logos.txt_description,
	  tbl_logos.var_link,
	  tbl_logos.var_src,
	  tbl_logos.var_size,
	  tbl_logos.int_order,
	  tbl_logos.int_id_logo
	FROM
	  tbl_partenaires
	  INNER JOIN tbl_logos ON (tbl_partenaires.id_int_partenaire = tbl_logos.id_int_partenaire)
	WHERE tbl_logos.int_id_state <> 3
	ORDER BY
	  tbl_partenaires.int_page,
	  tbl_logos.int_order";
	
	$res = mysql_query($sql, $cnn);
	
	$p = 0;
	while ($row = mysql_fetch_assoc($res))
	{
		$page = intval($row['int_page']);
		$src = $row['var_src'];
		$link = $row['var_link'];
		$size = explode("x", $row['var_size']);
		$idlogo = $row['int_id_logo'];
		$description = $row['txt_description'];
		
		$terminate = "";
		
		if($page != $p || $p == 0)
		{
			if($p > 0){
				$terminate = '</div></div>';
				$panel .= $terminate;
			}
			
			$p++; 

			$panel .= '<div class="panel">
				<span class="title">'.$page.'</span>
				<div class="panel-wrapper">';
		}
		
		if($page == $p)
		{
			$tooltiphtml .= '<div id="t-tooltip'.$idlogo.'" class="tooltiplogo">
				<div class="t-top"></div>
				<div class="t-middle">
					<img src="images/escudo.png" width="14" height="16"><span class="t-title">Info:</span><br />
					'. str_replace("\n","<br />", $description) . (($link) ? '<br /><span class="t-link">--<br /><a href="'.$link.'" target="_blank">Voir site web</a><br />--</span>' : '').'							
				</div>
				<div class="t-bottom"></div>
			</div>';
				
			$tooltips .= "$(\"#t-image".$idlogo."\").tooltip({tip: \"#t-tooltip".$idlogo."\", tipClass: \"tooltiplogo\"}); ";
			
			$image = (($link) ? '<a href="'.$link.'" target="_blank">' : '').'<img class="t-image-logos" id="t-image'.$idlogo.'" width="'.$size[0].'" height="'.$size[1].'" src="images/logos/'.$src.'" />'.(($link) ? '</a>': '');
			$panel .= $image;
		}
	}

	if($p > 0){
		$terminate = '</div></div>';
		$panel .= $terminate;
	}
	
	// Cerrar la coneccion obligatorio
	@mysql_close($cnn);
	
	echo $tooltiphtml;
?>

<div id="popup-partenaires">
    <div class="part-01"></div>
    <div class="part-02">
    	<div class="part-content">

    		<div class="coda-slider preload" id="sliderPartenaires">
				<?php echo $panel; ?>
            </div>

      </div>
     </div>
    <div class="part-03"></div>
</div>

<script type="text/javascript">
$(function(){
	<?php echo $tooltips; ?>
	$("#part-ess").tooltip({tip: "#t-tooltip-footer-ess", tipClass: "tooltiplogo"});
	$("#part-idfrance").tooltip({tip: "#t-tooltip-footer-idfrance", tipClass: "tooltiplogo"}); 
	$("#part-ffco").tooltip({tip: "#t-tooltip-footer-ffco", tipClass: "tooltiplogo"}); 
});
</script>


<!-- phpmyvisites 
<a href="http://www.phpmyvisites.net/" title="phpMyVisites : estadísticas y medida de audiencia de sitios en Internet (licencia GPL)" 
onclick="window.open(this.href);return(false);"><script type="text/javascript">

var a_vars = Array();
var pagename='';

var phpmyvisitesSite = 1;
var phpmyvisitesURL = "http://www.csme.fr/administration/phpmv2/phpmyvisites.php";

</script>
<script language="javascript" src="http://www.csme.fr/administration/phpmv2/phpmyvisites.js" type="text/javascript"></script>
<object><noscript><p>phpMyVisites : estadísticas y medida de audiencia de sitios en Internet (licencia GPL)
<img src="http://www.csme.fr/administration/phpmv2/phpmyvisites.php" alt="Statistics" style="border:0" />
</p></noscript></object></a>
phpmyvisites --> 

</body>
</html>